19. Quiz - Data Wrangling with DataFrames

Quiz

Answer these quiz questions. Use the "sparkify_log_small.json" file in the Spark Sandbox. You'll need to wrangle the data yourself to find the answers. You can use the Jupyter notebook in the next part of the lesson.

Answer code is provided after the Jupyter Notebook.

Which page did user id "" (empty string) NOT visit?

SOLUTION: NextSong

Reflect

QUESTION:

What type of user does the empty string user id most likely refer to?

ANSWER:

Users who are only visiting the About, Home and Login pages are probably unregistered visitors.

How many female users do we have in the data set?

SOLUTION: 462

How many songs were played from the most played artist?

SOLUTION: 83

How many songs do users listen to on average between visiting our home page? Please round your answer to the closest integer.

SOLUTION: 7